Analyzing Data with Power BI and Power Pivot for Excel (Business Skills) by Alberto Ferrari & Marco Russo

Author:Alberto Ferrari & Marco Russo [Ferrari, Alberto]
Language: eng
Format: azw3
Publisher: Pearson Education
Published: 2017-04-25T04:00:00+00:00

FIGURE 5-28 Denormalizing the historical manager in the fact table leads to a simple model.

Building the model is straightforward. You only need to compute, for each sale, the sales manager assigned to the customer’s country or region at the time of the sale. You can obtain this with a couple of merge operations—and, most importantly, without having to update the granularity of either the fact table or the dimension.

Regarding SCDs, here is a simple rule of thumb: If possible, try to isolate the slowly changing attribute (or set of attributes) and build a separate dimension for those attributes. You do not need to update the granularity. If the number of attributes is too large, then the best option is to go for the much more complex process of building a full SCD.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.